To change a Sql Server database collation, do the following: Connect to the Database Engine From the Standard bar, click New Query Copy and paste the following into the Query window and click Execute: ALTER DATABASE Licence SET RESTRICTED_USER; ALTER DATABASE Licence COLLATE SQL_Latin1_General_CP1_CI_AS; ALTER DATABASE Licence SET MULTI_USER; ALTER DATABASE DeMaSy SET RESTRICTED_USER; ALTER … Continue reading Query: How to change a Sql Server database collation